﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>SQLServerStatement Members</title>
    
    <link rel="stylesheet" type="text/css" href="../local/Classic.css">
      
    </link>
    
    <script src="../local/script.js">
      
    </script><script src="../local/script_main.js">&amp;nbsp;</script>
  </head>
  <body>
    <!--Topic built:12/06/2007 20:50:20-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="headerBold">SQLServerStatement Members</span>
          </td>
          <td align="right">
            
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      
        
        
		<font color="DarkGray"><!-- [This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]<br/>[Documentation built on $$TIMESTAMP$$]  --> </font> <p /> <p />
	
        <div id="introductionSection" class="section">
    <p>The following tables list the members that are exposed by the <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> class. </p>
  </div><h1 class="heading">Constructors</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">None.</p>
    </content></div><h1 class="heading">Fields</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">None.</p>
    </content></div><h1 class="heading">Inherited Fields</h1><div id="sectionSection2" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Name
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>java.sql.Statement</p>
          </td>
          <td>
            <p>CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Methods</h1><div id="sectionSection3" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Name
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>
              <a href="95924a8b-a43c-4133-aff6-1d712e60e234.htm">addBatch</a>
            </p>
          </td>
          <td>
            <p>Adds the given SQL command to the current list of commands for this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="276bd9c1-9329-4fc9-9622-ed673c83a12d.htm">cancel</a>
            </p>
          </td>
          <td>
            <p>Cancels the SQL statement that is currently being run by this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="e6fc1461-bbc6-45ae-85b1-a824aba51085.htm">clearBatch</a>
            </p>
          </td>
          <td>
            <p>Empties the current list of SQL commands for this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="b1d3a50c-3d05-44b3-b1ba-404a013fd627.htm">clearWarnings</a>
            </p>
          </td>
          <td>
            <p>Clears all the warnings that are reported on this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="84a25d64-dd3e-4696-bb5f-4eaf391fab7e.htm">close</a>
            </p>
          </td>
          <td>
            <p>Releases this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object's database and JDBC resources immediately instead of waiting for them to be automatically released.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="e1367f39-23d7-4e26-b160-6d988d7e6988.htm">execute</a>
            </p>
          </td>
          <td>
            <p>Runs the given SQL statement, which can return multiple results.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="fb034f63-2532-4da8-a1b0-bc125734585a.htm">executeBatch</a>
            </p>
          </td>
          <td>
            <p>Submits a batch of commands to the database to be run. If all commands run successfully, returns an array of update counts.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="599cf463-e19f-4baa-bacb-513cad7c6cd8.htm">executeQuery</a>
            </p>
          </td>
          <td>
            <p>Runs the given SQL statement and returns a single <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="10ae662a-ce3c-4b24-875c-5c2df319d93b.htm">executeUpdate</a>
            </p>
          </td>
          <td>
            <p>Runs the given SQL statement, which can be an INSERT, UPDATE, or DELETE statement; or an SQL statement that returns nothing, such as an SQL DDL statement.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="6f341d0b-265a-415e-abe5-8f408fedbb21.htm">getConnection</a>
            </p>
          </td>
          <td>
            <p>Retrieves the <a href="937292a6-1525-423e-a2b2-a18fd34c2893.htm">SQLServerConnection</a> object that produced this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="ceb4ae68-decc-46d3-83f1-0bbd23aaf58c.htm">getFetchDirection</a>
            </p>
          </td>
          <td>
            <p>Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="8115ca58-8ae9-46ce-8515-7905d7bb25fe.htm">getFetchSize</a>
            </p>
          </td>
          <td>
            <p>Retrieves the number of result set rows that is the default fetch size for result set objects generated from this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="a3325950-0e81-4ae8-aa0c-e1f6d371adcd.htm">getGeneratedKeys</a>
            </p>
          </td>
          <td>
            <p>Retrieves any auto-generated keys that are created as a result of running this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="ed7bbcb8-660b-4e9b-8241-e216c42826f9.htm">getMaxFieldSize</a>
            </p>
          </td>
          <td>
            <p>Retrieves the maximum number of bytes that can be returned for character and binary column values in a <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> object that is produced by this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="6aece4e5-027d-434e-a8cf-a67c0484f189.htm">getMaxRows</a>
            </p>
          </td>
          <td>
            <p>Retrieves the maximum number of rows that a <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> object that is produced by this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object can contain.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="6b18510a-4d6d-4eeb-a9d0-32e920eb0048.htm">getMoreResults</a>
            </p>
          </td>
          <td>
            <p>Moves to the next result of this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="8dff954f-b458-4fa6-abe6-be62ff75e2b9.htm">getQueryTimeout</a>
            </p>
          </td>
          <td>
            <p>Retrieves the number of seconds the Microsoft SQL Server 2005 JDBC Driver will wait for this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object to run.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="a9a9ffdd-7ce3-4e0a-907c-34d6a54e6865.htm">getResponseBuffering</a>
            </p>
          </td>
          <td>
            <p>Retrieves the response buffering mode for this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="929a14e2-8e98-4c32-89aa-86733c717ec1.htm">getResultSet</a>
            </p>
          </td>
          <td>
            <p>Retrieves the current result as a <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="47ef6547-5ec7-4cf5-a4d4-e34cbeec72eb.htm">getResultSetConcurrency</a>
            </p>
          </td>
          <td>
            <p>Retrieves the result set concurrency for <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> objects that are generated by this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="053549ee-2018-47ab-9538-789dac2b150a.htm">getResultSetHoldability</a>
            </p>
          </td>
          <td>
            <p>Retrieves the result set holdability for <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> objects that are generated by this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="260da35f-ddf6-4111-8519-69956ea3072e.htm">getResultSetType</a>
            </p>
          </td>
          <td>
            <p>Retrieves the result set type for <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> objects that are generated by this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="e9570228-4500-44b6-b2f1-84ac050b5112.htm">getUpdateCount</a>
            </p>
          </td>
          <td>
            <p>Retrieves the current result as an update count.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="3d6decae-2570-4ca5-8ff6-57a2cc3e921f.htm">getWarnings</a>
            </p>
          </td>
          <td>
            <p>Retrieves the first warning that is reported by calls on this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="3f3ec4f2-103a-4e16-9206-c5bd8639f946.htm">setCursorName</a>
            </p>
          </td>
          <td>
            <p>Sets the SQL cursor name to the given String, which will be used by subsequent execute methods.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="6ac0682e-e04c-4fdb-893b-92408d42051e.htm">setEscapeProcessing</a>
            </p>
          </td>
          <td>
            <p>Sets the escape processing mode.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="18176517-2fb3-4266-924d-0f01253083d2.htm">setFetchDirection</a>
            </p>
          </td>
          <td>
            <p>Gives the JDBC driver a hint as to the direction in which result set rows should be processed.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="760e555e-9667-4b40-b0ba-778026ff2923.htm">setFetchSize</a>
            </p>
          </td>
          <td>
            <p>Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="38f7fc1d-acad-4d10-9fc8-3c0669d93b07.htm">setMaxFieldSize</a>
            </p>
          </td>
          <td>
            <p>Sets the limit for the maximum number of bytes in a <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> column storing character or binary values to the given number of bytes.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="cccc0667-589b-4655-8ea8-14ae8b2eb9dc.htm">setMaxRows</a>
            </p>
          </td>
          <td>
            <p>Sets the limit for the maximum number of rows that any <a href="eaffcff1-286c-459f-83da-3150778480c9.htm">SQLServerResultSet</a> object can contain to the given number.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="0c513265-cd0c-4b38-9494-94458c17a16d.htm">setQueryTimeout</a>
            </p>
          </td>
          <td>
            <p>Sets the number of seconds the driver will wait for a <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object to run to the given number of seconds.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="9f489835-6cda-4c8c-b139-079639a169cf.htm">setResponseBuffering</a>
            </p>
          </td>
          <td>
            <p>Sets the response buffering mode for this <a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement</a> object to case-insensitive<b> String full</b> or <b>adaptive</b>.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Inherited Methods</h1><div id="sectionSection4" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Class inherited from:
            </th>
            <th>
              Methods
            </th>
          </tr><tr>
          <td>
            <p>java.lang.Object</p>
          </td>
          <td>
            <p>clone, equals, getClass, hashCode, notify, notifyAll, toString, wait</p>
          </td>
        </tr></table>
    </content></div><span id="seeAlsoSpan"><h1 class="heading">另请参见</h1></span><div id="seeAlsoSection" class="section" name="collapseableSection"><a href="ec24963c-8b51-4838-91e9-1fbfa2347451.htm">SQLServerStatement Class</a><br /><br />
		
		<b>
			
			
		</b>
	</div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]-->
      <div id="footer" class="section">
        
		<hr />  <span id="fb" class="feedbackcss"> </span> 
		<a href="9bad553b-9e70-4696-8499-2e35f772a1e0.htm">
			
			© 2007 Microsoft Corporation。保留所有权利。
		</a>
 	
	
      </div>
    </div>
  </body>
</html>